UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpjSf8vHvwvOuH/btD/dH+ZkO+b+Q6339v17SWcpqps='
WHERE
key_id = '7828ba7eabaddf50043b5914706ed283c4db7829a73794d0bf9a27270f771beb'
AND (
token = 'tpjSf8vHvwvOuH/btD/dH+ZkO+b+Q6339v17SWcpqps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)