UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I6HdbkdFiU4+LLdeQjibPj3A8ZGHrneu1qyAMqUc9aU='
WHERE
key_id = 'bd7f6c6fefe574005362c9a952ec7fc53e72344e0fd0379dc4c70da5c465f952'
AND (
token = 'I6HdbkdFiU4+LLdeQjibPj3A8ZGHrneu1qyAMqUc9aU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)