UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZeHQNXo3r57lkKUa9/HQHT3XXQoQ4eUiTUWCVPAPQsY='
WHERE
key_id = '1c9ab83dd958f1adf9791ae7e984a9750ed3af5e18b989255e3283305ccc5263'
AND (
token = 'ZeHQNXo3r57lkKUa9/HQHT3XXQoQ4eUiTUWCVPAPQsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)