UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pb67a4ju8ygD6eO2IRz8wOnzkZs1dthv9ueEQT0Eqns='
WHERE
key_id = '7cc9d3a2a6b0167153bbfa47ae437ba30ef301d43e418edfc519205b1e94ff4a'
AND (
token = 'pb67a4ju8ygD6eO2IRz8wOnzkZs1dthv9ueEQT0Eqns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)