UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ztIzAnBv1xnEcC8G7DjGtICQL44l8CKH4UIyD6q3nw4='
WHERE
key_id = '3cffb84de563838c8d0463c169bacc19393ad7f40124ec7253ff3837d703eaec'
AND (
token = 'ztIzAnBv1xnEcC8G7DjGtICQL44l8CKH4UIyD6q3nw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)