UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIZXxeyH0V2/hKFfAU3cMwBKAC+6lWk58hJeFaPDVJM='
WHERE
key_id = 'b16eb27f1d9c9ccf3f1b8539e49d389af9c3ac2122c0ad0163c2f1b1138b8a68'
AND (
token = 'mIZXxeyH0V2/hKFfAU3cMwBKAC+6lWk58hJeFaPDVJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)