UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jbO0VZKAp+MbaD2iHGWyuMHyPQaPjNeJOgYT2Ir66cs='
WHERE
key_id = 'f16e08b428538e80c145a773ab2e49b7d10235477e3689ddb3e8eaad1bc2cae6'
AND (
token = 'jbO0VZKAp+MbaD2iHGWyuMHyPQaPjNeJOgYT2Ir66cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)