UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'py/zD534QjXOgKz9yAQrMtWAOT78TkOpTdJJZlYkfqA='
WHERE
key_id = 'be31458def71849fb777e7009d6969fa1bd9b88553309feff38a61f0bd246d80'
AND (
token = 'py/zD534QjXOgKz9yAQrMtWAOT78TkOpTdJJZlYkfqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)