UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LIprVUNfMHE12igzDnASzIYdLRf2Rcdw7fufRihLos4='
WHERE
key_id = '9e946b7e0ab4187ac7201933abc1bac36b34b9996dfff7dc7b5a6b78db29c16e'
AND (
token = 'LIprVUNfMHE12igzDnASzIYdLRf2Rcdw7fufRihLos4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)