UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zX7rVx/YDyhwuaAWdLs9CD9MpmNrnTTOBxPWvXC+/kI='
WHERE
key_id = 'a954b2fe4d41d7037f46d80f23066feb8a6915e31c1bae63cd4fc40fa720fcd1'
AND (
token = 'zX7rVx/YDyhwuaAWdLs9CD9MpmNrnTTOBxPWvXC+/kI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)