UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pUIRRFJ+4N5Sy3hVR2dKm31FUI3pFe80nGGat3v7IyY='
WHERE
key_id = 'a3e0b9a1afc2a9e0bbd49b8670142b36c2474222a121a00e3f01029a3e99fe8c'
AND (
token = 'pUIRRFJ+4N5Sy3hVR2dKm31FUI3pFe80nGGat3v7IyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)