UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgCAdZvUXtABOWKn72+iwLuoYBbSqnytZWi/npzIorw='
WHERE
key_id = '863ff0e1b34f7e6dd08621773a403ecad8ed9985c65b6786df08062d446b77df'
AND (
token = 'pgCAdZvUXtABOWKn72+iwLuoYBbSqnytZWi/npzIorw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)