UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRd9SlWIX9e8egyQ5aD6D0hXDknZ7Ns6OIWwrT/+66k='
WHERE
key_id = 'f0d70e0ab63069a63e537474bff6c7f0fd2142ead808dcf759dd9a937993db7e'
AND (
token = 'pRd9SlWIX9e8egyQ5aD6D0hXDknZ7Ns6OIWwrT/+66k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)