UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2mJxpAF2kNo8NqAaN6Rwk5/GZ6OZapnWvgHGE1SCQ1w='
WHERE
key_id = '34b130110577fb90355b4faeb46c821621a3c1beac5edab2e64953ec83ec6be1'
AND (
token = '2mJxpAF2kNo8NqAaN6Rwk5/GZ6OZapnWvgHGE1SCQ1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)