UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tpDjMKc1WUiQXk7kh0p3gAedKCQDOJW4klA5yEQyR0='
WHERE
key_id = '4db48f65e8cf3a8f1f2aa48c22a4501907e9f542b2ad71f49ced5f37719349c6'
AND (
token = '8tpDjMKc1WUiQXk7kh0p3gAedKCQDOJW4klA5yEQyR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)