UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J0oR3+2k6Oqr0CBSIzpacBTJRorihjebdRHa90P6l00='
WHERE
key_id = 'ffd706ba912eb03055da6bae784b1a425a314b72fd509cd38bd3d5f2e12ec8a2'
AND (
token = 'J0oR3+2k6Oqr0CBSIzpacBTJRorihjebdRHa90P6l00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)