UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D2gYQSOxXwKGCBKd6ajDevzTlukF+tLVTR6v9thAW+g='
WHERE
key_id = 'b46d98cd4dcf16c09bb507adafbec128ab3012aa35427a3f8a6c9d8cb2921868'
AND (
token = 'D2gYQSOxXwKGCBKd6ajDevzTlukF+tLVTR6v9thAW+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)