UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JN8Vg0IOF6fPMx9LxCDB1T4HJ7YW4VZSb0Bjtluxho4='
WHERE
key_id = '5f8e9370872d40659bbfa21ef6f85300cf3e8a43dd320046f7d8274ab0f9ad67'
AND (
token = 'JN8Vg0IOF6fPMx9LxCDB1T4HJ7YW4VZSb0Bjtluxho4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)