UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XrEnseXAAT+UPmyxV5agnpKDhbL/Ol+iKydz0YdhZRw='
WHERE
key_id = 'f3449d5069da6c2ad739615c71ebb3ec2bd58a1cbd5315aff93337a8d8ea35a7'
AND (
token = 'XrEnseXAAT+UPmyxV5agnpKDhbL/Ol+iKydz0YdhZRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)