UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QEFN8F6OcVdJgkp3S0+rm9ic/V6K1ZirIRo7yp6w4SI='
WHERE
key_id = '478c9053d05417f270aff501565c0623bf27ab09fcd06950aa8f7339ed6fe560'
AND (
token = 'QEFN8F6OcVdJgkp3S0+rm9ic/V6K1ZirIRo7yp6w4SI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)