UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKfrH/OsDFkAk0AuPYalBK9WBGbNkCdlhK7K785ptx0='
WHERE
key_id = '116a4eae5ac9a21c987cf663b347df6fac6c93cd27a9cc7a3b835f229db0d566'
AND (
token = 'lKfrH/OsDFkAk0AuPYalBK9WBGbNkCdlhK7K785ptx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)