UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VX+XtLa9BNHHzNpSOMF8InEzCGIizAAwCJ5WU2otzSs='
WHERE
key_id = '6b3880d06ca1da525d9a953796d526d4434f7201462a44d6cb7bb57de9caf917'
AND (
token = 'VX+XtLa9BNHHzNpSOMF8InEzCGIizAAwCJ5WU2otzSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)