UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VfC16qBNPTW1QB7fyM4C4aqp7vznL4rXezCw+vn1Mg8='
WHERE
key_id = 'c6a7758447c3c5e95658d13f1d9b3bb54ca4ac0114ef32717cb72fe7d650296e'
AND (
token = 'VfC16qBNPTW1QB7fyM4C4aqp7vznL4rXezCw+vn1Mg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)