UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCnE7dp2GEBZodYdCMrJHRzB7C0t4zZ4Rj8XjtpICiA='
WHERE
key_id = '9be2d97b4a28db501a67f1b1c5f4a220176a0456b341bf1291e8180a0a1ddb71'
AND (
token = 'NCnE7dp2GEBZodYdCMrJHRzB7C0t4zZ4Rj8XjtpICiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)