UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cg106dVYz8QICIx/02i3ptSVToby6bI37k2zzL9AfCA='
WHERE
key_id = '3c2e5729c481b6c831221d2afb8148e3b14e18ed4925671deaf0142f2e76fec6'
AND (
token = 'Cg106dVYz8QICIx/02i3ptSVToby6bI37k2zzL9AfCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)