UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgopkAMw2YWU6BTN06QuXE8VpyA+CeHKQreLNI/KMjY='
WHERE
key_id = 'f0a164fd8ca98d7037e16a30e6880c59ff74cd63bec7e2dcd28a56d24d6a33c1'
AND (
token = 'lgopkAMw2YWU6BTN06QuXE8VpyA+CeHKQreLNI/KMjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)