UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ro55hOVNHr4qZzcqQGacU1pIBNeGSogPc5j7TBB89a8='
WHERE
key_id = '95d710f7ecade2ac150a1de018eef0305964f5f4a79d446bb4a4f02886a433c1'
AND (
token = 'ro55hOVNHr4qZzcqQGacU1pIBNeGSogPc5j7TBB89a8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)