UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5HjGx5/j/NJSktU9m6MlpgOnhBk8hRl/JiQc4RF5gqY='
WHERE
key_id = '6ec066f905f0bdf04006e273fcb0b07509d44ed0aa9fe41209338db987c726c9'
AND (
token = '5HjGx5/j/NJSktU9m6MlpgOnhBk8hRl/JiQc4RF5gqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)