UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iSOEoxJ6/BC3V8cIfwACon04TeRa8HuOT8orwp9reM='
WHERE
key_id = '2f77416edb40eeca5d9e23670327c94a055263fd21dca7ecf7382f8509931ffe'
AND (
token = '8iSOEoxJ6/BC3V8cIfwACon04TeRa8HuOT8orwp9reM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)