UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'On6+IznjmlSfB39zS/00+hIR5C2whS5N2PPS4Lsi3Tk='
WHERE
key_id = '83c594b8610872c2aea49808e4928ce9fde2d62564c2e7105683e415c06c2b9a'
AND (
token = 'On6+IznjmlSfB39zS/00+hIR5C2whS5N2PPS4Lsi3Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)