UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rRUf7EaJYb7ltIrEMAY9NV6ShbtBLgtfqeSTOQLK4Ko='
WHERE
key_id = 'ca7b1f2937d4c4fb1fcf293d9a876702c82861ac5cac069f7d02768787c4ae69'
AND (
token = 'rRUf7EaJYb7ltIrEMAY9NV6ShbtBLgtfqeSTOQLK4Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)