UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hr7OAg0Kv5iDLzfUvFk4elRQhKgWyUUjwlZmeFD8YoY='
WHERE
key_id = '16b1bd90ccbb66d8e360896328184f282b4f83e216c0ea5c255aa91ddf536390'
AND (
token = 'Hr7OAg0Kv5iDLzfUvFk4elRQhKgWyUUjwlZmeFD8YoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)