UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8TmpR4xxQ1jaAimqUPTjhVu5mG92LP80E7J+3850qg='
WHERE
key_id = '912466b6b9e21b1a9b9efbc5c8cfd9eabecfd639a0d90c1841b4e5edcc2e6882'
AND (
token = 'R8TmpR4xxQ1jaAimqUPTjhVu5mG92LP80E7J+3850qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)