UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mPXpRZaU2d6FL8LgXjaI8nhV4+PyYatZoV/A/QaKJ14='
WHERE
key_id = '1730f54545a7ecca16cd82a6dc3d1300447e288e76d3555c2bd2806b7c40733d'
AND (
token = 'mPXpRZaU2d6FL8LgXjaI8nhV4+PyYatZoV/A/QaKJ14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)