UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qh1Xln16YBgDWvi8I6JE+suCzTT5DkYufSBAj7In+EI='
WHERE
key_id = '1f06e34324fb70d8aec363d8c8ccd0b3b7022e0865bc86a9b4f80900b78ef483'
AND (
token = 'Qh1Xln16YBgDWvi8I6JE+suCzTT5DkYufSBAj7In+EI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)